if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].sp_NhomHang_GetAllOrderByName') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].sp_NhomHang_GetAllOrderByName
GO

CREATE PROCEDURE sp_NhomHang_GetAllOrderByName
AS
	SELECT	A.ID,A.Ten 
		FROM NhomHang A
		INNER JOIN NganhHang B ON A.Ma_nganh_hang = B.ID
		order by a.ten